Hi, I'm working with PHP PDO and I have the following problem:

Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in /var/www/site/classes/enterprise.php on line 63

Here is my code:

public function getCompaniesByCity(City $city, $options = null) {

$database = Connection::getConnection();

if(empty($options)) { $statement = $database->prepare("SELECT * FROM empresas WHERE empresas.cidades_codigo = ?"); $statement->bindValue(1, $city->getId()); } else { $sql = "SELECT * FROM empresas INNER JOIN prods_empresas ON prods_empresas.empresas_codigo = empresas.codigo WHERE ";

foreach($options as $option) { $sql .= 'prods_empresas.produtos_codigo = ? OR '; }

$sql = substr($sql, 0, -4); $sql .= ' AND empresas.cidades_codigo = ?';

$statement = $database->prepare($sql);

echo $sql;

foreach($options as $i => $option) { $statement->bindValue($i + 1, $option->getId()); }

$statement->bindValue(count($options), $city->getId()); }

$statement->execute();

$objects = $statement->fetchAll(PDO::FETCH_OBJ); $companies = array();

if(!empty($objects)) { foreach($objects as $object) { $data = array( 'id' => $object->codigo, 'name' => $object->nome, 'link' => $object->link, 'email' => $object->email, 'details' => $object->detalhes, 'logo' => $object->logo );

$enterprise = new Enterprise($data);
array_push($companies, $enterprise);

}

return $companies; } }

Thank you very much!